﻿CREATE TABLE [dbo].[WarehouseAdjustDetail] (
    [BillNo]      VARCHAR (30)    NOT NULL,
    [LineNo]      VARCHAR (3)     NULL,
    [ProductNo]   VARCHAR (10)    NOT NULL,
    [LotNo]       VARCHAR (20)    NULL,
    [ProductDate] DATETIME        NULL,
    [Qty]         NUMERIC (10, 2) NOT NULL,
    [AidQty]      NUMERIC (10, 2) NULL,
    [Location]    VARCHAR (20)    NULL,
    [Remark]      VARCHAR (60)    NULL,
    [RecordId]    INT             IDENTITY (1, 1) NOT NULL
);

